package com.orange;

public class SQLparams {
	// 中国柑橘产量
	public static String view_sql_01 = "select distinct NianFen as 'value' ,NianFen as 'show' from orange_z_chanliang ";
	public static String view_sql_02 = "select distinct ShengFen as 'value',ShengFen as 'show' from orange_z_chanliang ";
	// 中国柑橘面积
	public static String view_sql_03 = "select distinct NianFen as 'value',NianFen  as 'show' from orange_z_mianji ";
	public static String view_sql_04 = "select distinct ShengFen as 'value',ShengFen  as 'show' from orange_z_mianji ";
	// 中国柑橘进出口
	public static String view_sql_05 = "select distinct NianFen as 'value',NianFen as 'show' from orange_z_jinchuliang ";
	public static String view_sql_06 = "select distinct orange_z_jinchuliang.BianHao as 'value',orange_z_jinchuliang.BianHao as 'show'  from orange_z_jinchuliang";
	// 中国柑橘成本收益
	public static String view_sql_07 = "select distinct Pinzhong as 'value',Pinzhong as 'show' from orange_z_cbsy ";
	public static String view_sql_08 = "select distinct NianFen as 'value',NianFen as 'show' from orange_z_cbsy ";
	public static String view_sql_09 = "select distinct ShengFen as 'value',ShengFen as 'show' from orange_z_cbsy ";
	public static String view_sql_10 = "select distinct Class as 'value',Class as 'show' from orange_z_cbsy ";

	// 世界各国柑橘产量与面积
	public static String view_sql_11 = "select distinct NianFen as 'value',NianFen as 'show' from orange_w_changliangandmianji ";
	public static String view_sql_12 = "select distinct GuoJia as 'value',GuoJia as 'show' from orange_w_changliangandmianji ";
	public static String view_sql_13 = "select distinct PinZhong as 'value',PinZhong as 'show'  from orange_w_changliangandmianji ";

	// 世界各国柑橘贸易
	public static String view_sql_14 = "select distinct NianFen as 'value',NianFen as 'show'  from orang_w_jinchumaoyi ";
	public static String view_sql_15 = "select distinct Chu_GuoJia as 'value',Chu_GuoJia as 'show' from orang_w_jinchumaoyi ";
	public static String view_sql_16 = "select distinct Jin_GuoJia as 'value',Jin_GuoJia as 'show' from orang_w_jinchumaoyi ";
	public static String view_sql_17 = "select distinct BianHao as 'value',orange_z_pz.show as 'show' from orang_w_jinchumaoyi ,orange_z_pz where orang_w_jinchumaoyi.BianHao=orange_z_pz.value";

	public static String[] views_sql = { view_sql_01, view_sql_02, view_sql_03,
			view_sql_04, view_sql_05, view_sql_06, view_sql_07, view_sql_08,
			view_sql_09, view_sql_10, view_sql_11, view_sql_12, view_sql_13,
			view_sql_14, view_sql_15, view_sql_16, view_sql_17 };


}
